package org.example.hospital_registration_system.mapper;


import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface IDoctorInfoMapper {

    /*
    * 根据医生ID查询医生姓名
    * */
    @Select("SELECT doctor_name FROM doctor WHERE doctor_id = #{doctorId}")
    String getDoctorNameById(Integer doctorId);

    /*
    * 根据level查医生id
    * */
    @Select("SELECT doctor_id FROM doctor WHERE level = #{level}")
    List<Integer> getDoctorIdByLevel(Integer level);


}
